Excel worksheet function statistical data for statistical analysis. For example, the statistical worksheet function can be used to sample the variance of statistics, data distribution, such as the frequency range. Is not that seems to be very professional in what areas? Yes, the statistical worksheet function to provide a lot of statistical areas are a function, but also a matter of fact, some function in your daily life, I was very commonly used, such as grade point average for class rank, etc.. In this article, introduces some common statistical functions, and are not a function of statistical areas to go into details, detailed ways to use Excel to help and related reference books.

statistics, please click the schedule you look at the function name. Is found that some functions are very similar, but more in the name of a letter A? For example, AVERAGE and AVERAGEA; COUNT and COUNTA. Basically, the name of the function with A, not only in statistics on statistics, and text and logic of values (such as TRUE and FALSE) will also be taken into account. Below I will focus on non-A function of several common use.

a statistical average for the function for AVERAGE, TRIMMEAN

1, and the arithmetic mean function parameters AVERAGE
Grammatical form of AVERAGE (number1, number2, ...)
Which Number1, number2, ... In order to calculate the average of 1 to 30 parameters. These parameters can be digital, or is related to the number of names, array or reference. If the array or cell reference parameters in the text, logical values or empty cells, then ignore their values. However, if the cell contains a zero value into account.

2, for data sets of average Internal TRIMMEAN
Function TRIMMEAN data sets from the head and tail to remove a certain percentage of data points, and then the average demand. When the hope that removed part of the analysis of calculation data, you can use this function. For example, we calculated the average scores of players used to remove a maximum points, removing a minimum points, XX players its final score, you can use this function to calculate.
Grammatical form of TRIMMEAN (array, percent)
Array for which the need for screening and for the average of the array or data. Percent for the purpose of calculating when to remove the proportion of data points, for example, if percent = 0.2, in 20 of the collection of data points, it is necessary to remove the four data points (20 x 0.2), remove the head 2, the tail removed 2 months. TRIMMEAN function will remove the number of data points down homes to the nearest multiple of 2.

3, for example: the example cited with a function A method of AVERAGEA.
Annie players for the team scores. Here, we first assume that the scores of players have already carried out in the end from a high ranking, in the back of the presentation we will learn more about ways to sort.

Figure 1